{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Two Dwelling Unit 2024","Sheet1"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Two Dwelling Unit 2024","index":0,"n_rows":51,"n_cols":23,"rows_kept":51,"cut":false,"hidden":false,"merged":[[41,3,41,19],[32,13,32,18],[31,17,31,18],[34,12,35,19],[36,12,37,19],[34,2,35,9],[36,2,36,9],[50,1,50,5],[50,7,50,11],[48,13,50,19],[49,1,49,5],[49,7,49,11],[44,3,45,19],[29,11,29,12],[29,13,29,14],[29,15,29,16],[30,15,30,16],[30,17,30,18],[47,2,47,19],[33,2,33,9],[39,3,40,19],[42,3,43,19],[31,15,31,16],[27,15,27,16],[26,2,26,10],[29,17,29,18],[29,2,29,10],[31,11,31,12],[31,13,31,14],[30,2,30,10],[31,2,31,10],[30,11,30,12],[30,13,30,14],[27,11,27,12],[27,17,27,18],[26,11,26,12],[28,17,28,18],[27,2,27,10],[27,13,27,14],[28,2,28,10],[28,11,28,12],[28,13,28,14],[28,15,28,16],[20,13,20,14],[8,2,8,4],[9,2,9,4],[8,6,8,14],[20,15,20,16],[20,17,20,18],[5,2,5,18],[6,2,6,18],[7,2,7,18],[19,11,19,12],[19,13,19,14],[19,15,19,16],[19,17,19,18],[11,2,13,18],[19,2,20,10],[20,11,20,12],[9,6,9,14],[15,2,15,7],[21,15,21,16],[21,17,21,18],[21,2,21,10],[21,11,21,12],[21,13,21,14],[17,13,17,14],[17,17,17,18],[17,2,17,10],[22,17,22,18],[22,2,22,10],[23,15,23,16],[23,17,23,18],[23,2,23,10],[23,11,23,12],[23,13,23,14],[22,11,22,12],[22,13,22,14],[24,2,24,10],[25,11,25,12],[25,2,25,10],[24,11,24,12],[24,13,24,14],[22,15,22,16],[24,15,24,16],[24,17,24,18],[26,15,26,16],[26,13,26,14],[25,15,25,16],[25,17,25,18],[26,17,26,18],[25,13,25,14]]}
[]
[]
[]
[]
[]
[null,null,"WATER PIPE SIZING DATA SHEET  "]
[null,null,"HOUSE WITH TWO DWELLING UNITS FOR 2024 ONTARIO BUILDING CODE"]
[]
[null,null,"Address:"]
[null,null,"Permit Application #:"]
[]
[null,null,"The Ontario Building Code Div. B, 7.6.3 regulates size and capacity of pipes for a new house. Please enter the number of individual fixtures as listed and bathroom groups or powder room groups per floor. The fixture units and required minimum size of water service will automatically be calculated."]
[]
[]
[]
[null,null,"Size of Existing Water Service (inch)",null,null,null,null,null,null,null,"½\"",null,"⅝\"",null,"¾\"",null,"1\"",null,"1¼\""]
[]
[null,null,"Material Of Existing Water Service (Please Select)",null,null,null,null,null,null,null,null,null,false,"Copper",null,null,false,"Plastic"]
[]
[null,null,"Description ",null,null,null,null,null,null,null,null,"Basement Floor ",null,"First Floor",null,"Second Floor",null,"Third Floor"]
[null,null,null,null,null,null,null,null,null,null,null,"Qty.",null,"Qty.",null,"Qty.",null,"Qty."]
[null,null,"Bathroom group                                                                                            A bathroom group consists of 1 water closet, 1 lavatory, and 1 bathtub (with or without showerhead)"]
[null,null,"Bidet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Extra Shower (count this if there is a bathtub and a separate shower in the bathroom)"]
[null,null,"Lavatory  (Bathrooms sink, count this if there is more than one bathroom sink in the bathroom)"]
[null,null,"Bar Sink"]
[null,null,"Powder room                                                                                                     A powder room group consists of 1 water closet and 1 lavatory"]
[null,null,"Kitchen Sink "]
[null,null,"Dishwasher"]
[null,null,"Laundry Tub"]
[null,null,"Washing Machine"]
[null,null,"Hose Bibb                                                                                                             A hose bibb is an outside faucet or a faucet in a garage"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Hose Bibb In Garage To Be Removed"]
[null,null,"Maximum Total Fixture Units",null,null,null,null,null,null,null,null,{"$f":"(L22+N22+P22+R22)*3.6+(L23+N23+P23+R23)*2+(L24+N24+P24+R24)*1.4+(L25+N25+P25+R25)*0.7+(L26+N26+P26+R26)*1+(L27+N27+P27+R27)*2.9+(L28+N28+P28+R28)*1.4+(L29+N29+P29+R29)*1.4+(L30+N30+P30+R30)*1.4+(L31+N31+P31+R31)*1.4+(L32+N32)*2.5","v":0}]
[null,null,"Size Of Copper Water Services (Inch)",null,null,null,null,null,null,null,null,{"$f":"IF(L34>57,\"Note:\",IF(L34>31,\"1¼\",IF(L34>16,\"1\",IF(L34>0,\"3/4\",\"\"))))","v":""},{"$f":"IF(L34>57,\"If the total fixture units more than 57 fixture unit, the water pipe size shall be designed as per the ASHRAE Handbooks and ASPE Data Books.R42\",IF(L34>30,\"Ø\",IF(L34>0,\"Ø\",IF(L34=0,\"Please complete the above table\"))))","v":"Please complete the above table"}]
[]
[null,null,"Size Of Plastic Water Services (Inch)",null,null,null,null,null,null,null,null,{"$f":"IF(L34>83,\"Note:\",IF(L34>43,\"1¼\",IF(L34>21,\"1\",IF(L34>0,\"3/4\",\"\"))))","v":""},{"$f":"IF(L34>57,\"If the total fixture units more than 83 fixture unit, the water pipe size shall be designed as per the ASHRAE Handbooks and ASPE Data Books.R42\",IF(L34>30,\"Ø\",IF(L34>0,\"Ø\",IF(L34=0,\"Please complete the above table\"))))","v":"Please complete the above table"}]
[]
[null,null,"Note:"]
[null,null,"(1)","If the existing water service is 1/2\" or 5/8\" in size, it will be required to replaced and upgraded in size to match the requirement of this data sheet."]
[]
[null,null,"(2)","When the water service is required to be replaced, a copy of the Site Plan it is required and shall show the location and the size of the proposed water service."]
[null,null,"(3)","The water pipe after the water meter shall be the size that is calculated on this sheet and shall maintain the size up to the branch for the hot water tank and the branches for the water supply to each dwelling unit."]
[]
[null,null,"(4)","Each dwelling shall have a valve installed on the hot and cold water supply in such a manner that shutting off the water supply to one dwelling unit will not affect the water supply to any other dwelling unit."]
[]
[]
[null,null,"Disclaimer: \nProviding any false information on this form may lead to delays in closing the permits, may incur additional costs and a revision to the original permit may be required. "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"I hereby certify that, to the best of my knowledge, the provided information is true and accurate."]
["*"]
[null,"Signature (Owner or Applicant)",null,null,null,null,null,"Name (Owner or Applicant)"]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}